package com.monitor.service;

import com.baomidou.mybatisplus.service.IService;
import com.monitor.entity.ErpOrderd;
import com.monitor.util.Result;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 需求汇总表 服务类
 * </p>
 *
 * @author LX
 * @since 2018-09-11
 */
public interface ErpOrderdService extends IService<ErpOrderd> {
    List<Integer> getOrderdId(String materielName,String materielBrand,String specifications, String model);
    
    public Result<String> selectSheetId(String time);
    
    public Result<Integer> addOrderd(ErpOrderd ord,String json);
    
    public Result<List<Map<String, Object>>> selectOrderByTime(String startTime,String endTime,int custId);
    
    public Result<Integer> deleteOrder(int orderId);
    
    public Result<Map<String, Object>> selectByOrderId(int orderId);
    
    public Result<List<Map<String, Object>>> selectByType(String startTime,String endTime,int custId);
    
    //采购订单需求汇总查询 
    public Result<List<Map<String, Object>>> selectByCustId(int custId);
    
  //需求汇总 订单排列查询方法
    public Result<List<Map<String, Object>>> selectByOrderList(String startTime,String endTime,int custId);
 }
